TCustomDAConnection.ExecSQL Method

Executes a SQL statement with parameters.

Class

Syntax

function ExecSQL(const Text: string): variant; overload;function ExecSQL(const Text: string; const Params: array of variant): variant; overload; virtual;

Parameters

Text

a SQL statement to be executed.

Params

Array of parameter values arranged in the same order as they appear in SQL statement.

Return Value

Out parameter with the name Result will hold the result of function having data type dtString. Otherwise returns Null.

Remarks

Use the ExecSQL method to execute any SQL statement outside the TCustomDADataSet or TCustomDASQL components. Supply the Params array with the values of parameters arranged in the same order as they appear in a SQL statement which itself is passed to the Text string parameter.

TCustomDAConnection.ExecSQL Method

Class

Syntax

Remarks

See Also